How to: Hide duplicate data in a report.
Solution:
In the Report Design view, use the 'Hide Duplicates' property box in the selected controls property sheet to hide duplicate data in a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the desired control for hiding duplicates. (Handles appear around the selected controls.)
NOTE: Select a control that has duplicate data.
6) Select the 'View' menu and select 'Properties'.
7) Click the 'Format' tab.
8) Click on the 'Hide Duplicates' box. (A down arrow appears.)
9) Click down arrow. (A drop-down list appears.)
10) Select 'Yes' from the 'Hide Duplicates' drop-down list.
11) Select the 'File' menu and select 'Save' to save the report.
